-
1. Re: JBoss newbie: Connecting to JDBC
gary_kephart Jan 29, 2003 8:53 PM (in response to gary_kephart)One step closer...
Note to self: always throw "new EJBException(ex)" and not "new EJBException(ex.toString())". Helps stack trace.
Now I get this exception line in the log file:
at org.hsqldb.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.java:133)
Looks like it's going to a Hyperion db instead of mine. Why?
Looks like it's bound to DefaultDS, if hsqldb-service.xml is any clue:
DefaultDS
The server.log file shows
2003-01-29 16:12:56,141 INFO [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.DefaultDS] Bound connection factory for resource adapter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/DefaultDS'
Am I mapping bahiawebDB to JBoss LocalTransaction JDBC Wrapper? Back to searching for an answer. -
2. Re: JBoss newbie: Connecting to JDBC
gary_kephart Feb 3, 2003 1:22 PM (in response to gary_kephart)Finally got it working. See attachment
-
3. Re: JBoss newbie: Connecting to JDBC
goldrimtang Mar 1, 2003 2:16 PM (in response to gary_kephart)Thanks for your info, it's been very helpful !!
-
4. Re: JBoss newbie: Connecting to JDBC
ndijkstra Mar 10, 2003 7:28 AM (in response to gary_kephart)I used your access datasource configuration as a sample but when i deploy it, i get a warn message:
09:41:09,699 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=pedidosDB does not implement
any Service methods -
5. Re: JBoss newbie: Connecting to JDBC
gary_kephart Mar 10, 2003 1:42 PM (in response to gary_kephart)Could you post your -service.xml file?
-
6. Re: JBoss newbie: Connecting to JDBC
ndijkstra Mar 10, 2003 1:59 PM (in response to gary_kephart)Despite the warning i get, the datasource works fine. The only problem i have is that i have to manually start the service through the administrator.
Why is it that i don't automatically get the datasource binded to de JNDI????
Please, i need help!! -
7. Re: JBoss newbie: Connecting to JDBC
gary_kephart Mar 10, 2003 3:38 PM (in response to gary_kephart)> Despite the warning i get, the datasource works fine.
> The only problem i have is that i have to manually
> start the service through the administrator.
> Why is it that i don't automatically get the
> datasource binded to de JNDI????
> Please, i need help!!
Hmm. I've never had to start the service from the console. Having the service work even though there is a warning may not mean anything. There still may be a problem in the -service.xml file that's causing your problem. Please post it. -
8. Re: JBoss newbie: Connecting to JDBC
ndijkstra Mar 11, 2003 6:38 AM (in response to gary_kephart)This is the code of the file msaccess-service at
<jboss_home>/server/default/deploy.
I took the file from the examples directory, so it should work correctly.
<depends optional-attribute-name="ManagedConnectionFactoryName">
pedidosDB
<config-property name="ConnectionURL" type="java.lang.String">jdbc:odbc:pedidosDB</config-property>
<config-property name="DriverClass" type="java.lang.String">sun.jdbc.odbc.JdbcOdbcDriver</config-property>
<depends optional-attribute-name="OldRarDeployment">
jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
<depends optional-attribute-name="ManagedConnectionPool">
0
50
5000
15
ByNothing
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
java:/TransactionManager
jboss.jca:service=RARDeployer -
9. Re: JBoss newbie: Connecting to JDBC
gary_kephart Mar 13, 2003 7:46 PM (in response to gary_kephart)Well, you were right, the service file works fine. I looked through my log files, and my service file gives the same message.
So you say that the service has to be started through the admin console, right? What error message did you get when you didn't do that? -
10. Re: JBoss newbie: Connecting to JDBC
ndijkstra Mar 14, 2003 7:53 AM (in response to gary_kephart)I had no error message.
When requesting a secured page, no matter what login/password y entered, nothing happened. It just wasn't getting the connection to de datasource.
Now, i changed my JBoss to 3.0.4 and eveything works fine. Only God kowns why.
Thanks -
11. Re: JBoss newbie: Connecting to JDBC
gary_kephart Mar 14, 2003 12:01 PM (in response to gary_kephart)Best of luck, then!