You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "francisdb (JIRA)" <em...@incubator.apache.org> on 2008/12/26 16:49:44 UTC
[jira] Created: (EMPIREDB-31) advanced sample throws SQLException
(wrong db user)
advanced sample throws SQLException (wrong db user)
---------------------------------------------------
Key: EMPIREDB-31
URL: https://issues.apache.org/jira/browse/EMPIREDB-31
Project: Empire-DB
Issue Type: Bug
Components: Core
Reporter: francisdb
running the advanced example gives me:
java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
this is because SampleAdvConfig has the wrong value as user:
is:
private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
should be:
private String jdbcUser = "sa";
(I filed this issue before for the main example project, but it seems the advanced example has the same problem)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (EMPIREDB-31) advanced sample throws SQLException
(wrong db user)
Posted by "Rainer Döbele (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-31?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rainer Döbele closed EMPIREDB-31.
---------------------------------
Resolution: Cannot Reproduce
Assignee: Rainer Döbele
> advanced sample throws SQLException (wrong db user)
> ---------------------------------------------------
>
> Key: EMPIREDB-31
> URL: https://issues.apache.org/jira/browse/EMPIREDB-31
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Reporter: francisdb
> Assignee: Rainer Döbele
>
> running the advanced example gives me:
> java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
> this is because SampleAdvConfig has the wrong value as user:
> is:
> private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
> should be:
> private String jdbcUser = "sa";
> (I filed this issue before for the main example project, but it seems the advanced example has the same problem)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Re: [jira] Commented: (EMPIREDB-31) advanced sample throws SQLException (wrong db user)
Posted by Francis De Brabandere <fr...@gmail.com>.
Merging branches will be hard, as I'll have to move a lot of files,
I'll just do the same thing on trunk when everybody is ready to use
maven... and when I can reproduce the distribution file correctly.
I'm waiting for my apache login to be activated. After that I'll set
up the branch so that other committers can check it out and test the
mavenized project source.
On Fri, Jan 2, 2009 at 1:43 PM, Rainer Döbele <do...@esteam.de> wrote:
> Hi Francis,
>
> first of all we're happy that we have you now on the project and to find you so keen on improving the project.
>
> Creating a branch is certainly a good idea. There are (as far as I know) currently only minor bugfixes going on and it should be fairly simple to merge the branches later on.
>
> As far as your problem with loading the config.xml is concerned, it is no problem to change the Sample Application's code. Currently it is assumed that by default the config.xml can be found in the current directory which is the project's root directory in Eclipse.
>
> We should however give a hint if the config.xml cannot be found and the thus the hard coded default are being used, which was the problem in your case. I have now corrected the SampleAdvConfig defaults as a first step.
>
> Since I am a little busy at the moment I might not always be able to reply straight away, but I will try my best.
>
> Regards,
> Rainer
>
>
> francisdb commented on EMPIREDB-31:
> -----------------------------------
>
> it's the defaults in SampleAdvConfig.java that are wrong, I suppose I was not using the config.xml
>
>> advanced sample throws SQLException (wrong db user)
>> ---------------------------------------------------
>>
>> Key: EMPIREDB-31
>> URL: https://issues.apache.org/jira/browse/EMPIREDB-31
>> Project: Empire-DB
>> Issue Type: Bug
>> Components: Core
>> Reporter: francisdb
>> Assignee: Rainer Döbele
>>
>> running the advanced example gives me:
>> java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
>> this is because SampleAdvConfig has the wrong value as user:
>> is:
>> private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
>> should be:
>> private String jdbcUser = "sa";
>> (I filed this issue before for the main example project, but it seems the advanced example has the same problem)
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
Re: [jira] Commented: (EMPIREDB-31) advanced sample throws SQLException (wrong db user)
Posted by Rainer Döbele <do...@esteam.de>.
Hi Francis,
first of all we're happy that we have you now on the project and to find you so keen on improving the project.
Creating a branch is certainly a good idea. There are (as far as I know) currently only minor bugfixes going on and it should be fairly simple to merge the branches later on.
As far as your problem with loading the config.xml is concerned, it is no problem to change the Sample Application's code. Currently it is assumed that by default the config.xml can be found in the current directory which is the project's root directory in Eclipse.
We should however give a hint if the config.xml cannot be found and the thus the hard coded default are being used, which was the problem in your case. I have now corrected the SampleAdvConfig defaults as a first step.
Since I am a little busy at the moment I might not always be able to reply straight away, but I will try my best.
Regards,
Rainer
francisdb commented on EMPIREDB-31:
-----------------------------------
it's the defaults in SampleAdvConfig.java that are wrong, I suppose I was not using the config.xml
> advanced sample throws SQLException (wrong db user)
> ---------------------------------------------------
>
> Key: EMPIREDB-31
> URL: https://issues.apache.org/jira/browse/EMPIREDB-31
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Reporter: francisdb
> Assignee: Rainer Döbele
>
> running the advanced example gives me:
> java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
> this is because SampleAdvConfig has the wrong value as user:
> is:
> private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
> should be:
> private String jdbcUser = "sa";
> (I filed this issue before for the main example project, but it seems the advanced example has the same problem)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (EMPIREDB-31) advanced sample throws SQLException
(wrong db user)
Posted by "francisdb (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-31?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12659323#action_12659323 ]
francisdb commented on EMPIREDB-31:
-----------------------------------
it's the defaults in SampleAdvConfig.java that are wrong, I suppose I was not using the config.xml
> advanced sample throws SQLException (wrong db user)
> ---------------------------------------------------
>
> Key: EMPIREDB-31
> URL: https://issues.apache.org/jira/browse/EMPIREDB-31
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Reporter: francisdb
> Assignee: Rainer Döbele
>
> running the advanced example gives me:
> java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
> this is because SampleAdvConfig has the wrong value as user:
> is:
> private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
> should be:
> private String jdbcUser = "sa";
> (I filed this issue before for the main example project, but it seems the advanced example has the same problem)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (EMPIREDB-31) advanced sample throws SQLException
(wrong db user)
Posted by "francisdb (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-31?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12659443#action_12659443 ]
francisdb commented on EMPIREDB-31:
-----------------------------------
I came to this issue because in SampleConfig.java:
if (super.init(filename, false, true) == false){...}
the false argument indicates not to load as resource, which in maven context and maven generated eclipse context tries to read the file from:
/home/francisdb/workspace/empire-db-mvn/empire-db-example/config.xml but I placed it in the resources folder which is added to the classpath
we'll have to see how we deal with this when moving to maven. When the app starts up without the config file there is no indication that the file was not found because the logging subsystem is not set up yet...
> advanced sample throws SQLException (wrong db user)
> ---------------------------------------------------
>
> Key: EMPIREDB-31
> URL: https://issues.apache.org/jira/browse/EMPIREDB-31
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Reporter: francisdb
> Assignee: Rainer Döbele
>
> running the advanced example gives me:
> java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
> this is because SampleAdvConfig has the wrong value as user:
> is:
> private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
> should be:
> private String jdbcUser = "sa";
> (I filed this issue before for the main example project, but it seems the advanced example has the same problem)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (EMPIREDB-31) advanced sample throws SQLException
(wrong db user)
Posted by "Rainer Döbele (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-31?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12659320#action_12659320 ]
Rainer Döbele commented on EMPIREDB-31:
---------------------------------------
I have checked but could not find any problem running the DBSampleAdv.
The the config.xml in both the latest distribution and the SV repo has the correct settings:
<properties-hsqldb>
<!-- JDBC properties for a HSQLDB Database connection -->
<!-- Required jar file: hsqldb.jar -->
<jdbcClass>org.hsqldb.jdbcDriver</jdbcClass>
<jdbcURL>jdbc:hsqldb:file:hsqldb/sample;shutdown=true</jdbcURL>
<jdbcUser>sa</jdbcUser>
<jdbcPwd></jdbcPwd>
<schemaName>DBSAMPLEADV</schemaName>
</properties-hsqldb>
i.e. jdbcUser is set to "sa".
> advanced sample throws SQLException (wrong db user)
> ---------------------------------------------------
>
> Key: EMPIREDB-31
> URL: https://issues.apache.org/jira/browse/EMPIREDB-31
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Reporter: francisdb
>
> running the advanced example gives me:
> java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
> this is because SampleAdvConfig has the wrong value as user:
> is:
> private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
> should be:
> private String jdbcUser = "sa";
> (I filed this issue before for the main example project, but it seems the advanced example has the same problem)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (EMPIREDB-31) advanced sample throws SQLException
(wrong db user)
Posted by "francisdb (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-31?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
francisdb resolved EMPIREDB-31.
-------------------------------
Resolution: Fixed
Fix Version/s: empire-db-2.0.5-incubating
this issue is fixed in the new maven layout as we keep the settings.xml in the project root
> advanced sample throws SQLException (wrong db user)
> ---------------------------------------------------
>
> Key: EMPIREDB-31
> URL: https://issues.apache.org/jira/browse/EMPIREDB-31
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Reporter: francisdb
> Assignee: Rainer Döbele
> Fix For: empire-db-2.0.5-incubating
>
>
> running the advanced example gives me:
> java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
> this is because SampleAdvConfig has the wrong value as user:
> is:
> private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
> should be:
> private String jdbcUser = "sa";
> (I filed this issue before for the main example project, but it seems the advanced example has the same problem)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (EMPIREDB-31) advanced sample throws SQLException
(wrong db user)
Posted by "francisdb (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-31?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
francisdb reopened EMPIREDB-31:
-------------------------------
java source file code still needs a fix
> advanced sample throws SQLException (wrong db user)
> ---------------------------------------------------
>
> Key: EMPIREDB-31
> URL: https://issues.apache.org/jira/browse/EMPIREDB-31
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Reporter: francisdb
> Assignee: Rainer Döbele
>
> running the advanced example gives me:
> java.lang.RuntimeException: java.sql.SQLException: User not found: JDBC:HSQLDB:FILE:HSQLDB/SAMPLE;SHUTDOWN=TRUE
> this is because SampleAdvConfig has the wrong value as user:
> is:
> private String jdbcUser = "jdbc:hsqldb:file:hsqldb/sample;shutdown=true";
> should be:
> private String jdbcUser = "sa";
> (I filed this issue before for the main example project, but it seems the advanced example has the same problem)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.