[JBoss-user] [Datasource Configuration] - JBOSS Connection Pooling Exception

2006-06-29 Thread [EMAIL PROTECTED]
Hi I'm using SQL Server 2005 data base and I configured the data source in sql-ds.xml for jboss , the config contents are as follows CEDDS jdbc:sqlserver://10.239.5.159\SQLEXPRESS:1433;DatabaseName=1ced1 com.microsoft.sqlserver.jdbc.SQLServerDriver ced ced 1

[JBoss-user] [Datasource Configuration] - Restricting access to datasources

2006-05-17 Thread schuller007
Can I define a datasource that is only visible to my application's ejbs and not to other apps co-existing on the same server? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3944417#3944417 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posti

[JBoss-user] [Datasource Configuration] How to change jboss.jca:name=DefaultDS,service=DataSourceBinding

2004-10-13 Thread alexis
hi everybody, i'm trying to configure jboss 4 with mysql 4.0.21, i've changed every configuration file from jboss in order to point to MySqlDS instead of DefaultDs, however, when i startup jboss, i always get the error : ERROR [URLDeploymentScanner] Incomplete Deployment listing: MBeans wai

[JBoss-user] [Datasource Configuration] - Re: Jboss and Hypersonic

2004-04-06 Thread kengboy
So do I View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3829412#3829412 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3829412 --- This SF.Net email is sponsored by: IB

[JBoss-user] [Datasource Configuration] - Re: MS SQL Server And

2004-03-26 Thread felipestrm
have you tried jtds? I have used it succesfully with sql server 7. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3827687#3827687";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3827687>Reply to the post

[JBoss-user] [Datasource Configuration] - Re: MS SQL Server And

2004-03-26 Thread jxue
Do you know JBoss has JDBC driver other than using Microsoft SQL server 2000 sp2? Thanks http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3827683#3827683";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3827683>Reply to the post -

[JBoss-user] [Datasource Configuration] - Re: ORA-01453: SET TRANSACTION must be first statement of tr

2004-03-25 Thread murthytvsn
After diagnosing the code I found in one place after getting the connection we change the transaction type and before closing the connection we are setting it back to original transaction type. After commenting that code I never got that error. Thanks Murthy http://www.jboss.org/index.html?modu

[JBoss-user] [Datasource Configuration] - Re: ORA-01453: SET TRANSACTION must be first statement of tr

2004-03-24 Thread rajeshnarkhed
hi, i m gettiing the same error under load in prod server. The error occurs intermmitently during a JDBC insert . But my oracle-ds.xml doesnt contain the TRANSACTION_READ_COMMITTED tag. and it has the followinig values 0 100 5000 3 did u manage to get any workaround/solution for this

[JBoss-user] [Datasource Configuration] - Re: Postgres 7.4.1 - SET AUTOCOMMIT TO OFF is no longer supp

2004-03-24 Thread jrd
Eric, I had the same problem and I just downloaded the latest JDBC driver (7.4.1) and it fixed the problem. http://jdbc.postgresql.org/download.html --jD http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3827294#3827294";>View the original post http://www.jboss.org/index.html?module=bb

[JBoss-user] [Datasource Configuration] - CLOSED - CLOSED - CLOSED

2004-03-19 Thread [EMAIL PROTECTED]
This forum is closed you will be ignored if you post here. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826625#3826625";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826625>Reply to the post

[JBoss-user] [Datasource Configuration] - Re: Refreshing Connection Pools

2004-03-19 Thread vidyesh
We are using JBossManagedConnectionPool as MBean Service with following entries where I would also like to specify "exception-sorter-class-name" as "org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter". Question 1. How do I specify that ? There is no Setter/Getter method for Exception

[JBoss-user] [Datasource Configuration] - Re: Refreshing Connection Pools

2004-03-19 Thread vidyesh
We are using JBossManagedConnectionPool as MBean Service with following entries where I would also like to specify "exception-sorter-class-name" as "org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter". Question 1. How do I specify that ? There is no Setter/Getter method for Exception

[JBoss-user] [Datasource Configuration] - Re: Can anyone help me, i can't configure my JBoss 3.2.3 wit

2004-03-19 Thread [EMAIL PROTECTED]
You should post the error messages you're seeing, otherwise no one is able to help you. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826514#3826514";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826514>Reply to the post --

[JBoss-user] [Datasource Configuration] - Re: Postgres 7.4.1 - SET AUTOCOMMIT TO OFF is no longer supp

2004-03-17 Thread gonegolfin
Eric, Exactly which driver are you using now? I was using pg73jdbc3.jar with 7.3.2. I upgraded to PostgreSQL 7.4.1 and am seeing the same problem you are. I had thought that pg73jdbc3.jar is the latest. Thanks, Brian http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826197#3826197";>V

[JBoss-user] [Datasource Configuration] - Re: Unregistered handle that was not registered

2004-03-17 Thread [EMAIL PROTECTED]
It was a bug in 3.2.1 If an error occurred while you were using the connection, it tried to close the connection twice. Regards, Adrian http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826105#3826105";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=re

[JBoss-user] [Datasource Configuration] - Unregistered handle that was not registered

2004-03-17 Thread lee_yuki2000
I m using jboss 3.2.1. Do any one know why sometimes i get this error when connecting to the database. I am using oracle 9.1i [TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: [EMAIL PROTECTED] [JBossManagedConnectionPool] Ex

[JBoss-user] [Datasource Configuration] - Re: Refreshing Connection Pools

2004-03-16 Thread k2c
Hi to all, sorry about using this thread but i have a question regarding this matter but for jboss 2.4.9. How would i solve the same problem but for jboss 2.4.9? I think the easy solution will be the upgrade solution to the version 3.x, but i need to use the version 2.4.9. 1. Should i change

[JBoss-user] [Datasource Configuration] - Getting Datasource & java.lang.ClassCastException on applica

2004-03-16 Thread kmarcos
Hi. (first, sorry for my english) i get java.lang.ClassCastException when i tried to get DataSource on my application client... On LoaderRepository i get: org.jboss.resource.adapter.jdbc.WrapperDataSource Information Repository cache version: org.jboss.resource.adapter.jdbc.WrapperDataSource(9d

[JBoss-user] [Datasource Configuration] - Re: jboss 3.2.3 and arrayindexout of bound exception

2004-03-16 Thread DaGGeRRz
I submittet a bug report on this a month ago and JBoss claims it has been fixed in 3.2.4RC1. I haven't had the chance to test it yet, though since 3.2.4.RC1 breaks our Oracle XA connectors. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825896#3825896";>View the original post http:/

[JBoss-user] [Datasource Configuration] - Re: oracle.jdbc.xa.OracleXAException enlistResource failed

2004-03-16 Thread DaGGeRRz
Try setting the pad attribute to true in conf/jboss-service.xml. This works with 3.2.3 and 3.2.4RC1 from CVS two weeks ago. Does not work with the released RC1. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825894#3825894";>View the original post http://www.jboss.org/index.html?modu

[JBoss-user] [Datasource Configuration] - JBossLocalXAException

2004-03-14 Thread subhani
Hi Guys I am getting following exception. Can u please let me know why it is coming.. java.lang.ClassNotFoundException: org.jboss.resource.connectionmanager.JBossLocalXAException (no security manager: RMI class loader disabled) at org.apache.jasper.servlet.JspServletWrapper.service(Js

[JBoss-user] [Datasource Configuration] - Re: How to get the name of the datasource from within an EJB

2004-03-13 Thread neptune5
Hi Larry Cheers for that , that was were I was getting confused . I thought you had to have a postgresql_ds.xml ( for example and say a different one for a different database) . It all makes sense now I can have a myshop-ds.xml with a java:/myshop(jindi name) but actually connect to either a te

[JBoss-user] [Datasource Configuration] - Re: How to get the name of the datasource from within an EJB

2004-03-11 Thread larry054
Hi again Adrian, That's a slightly different question than I thought you were asking. If I understand correctly, you want to be able to connect to different databases with the same application without changing the source code. You may not realize it, but your datasource is not "cardcoded". You

[JBoss-user] [Datasource Configuration] - jboss 3.2.3 DeploymentExcepton: No attribute found with name

2004-03-11 Thread alanc_yang
I have the followings in hsqldb-service.xml file and when it's deployed it encountered with error. Wonder anybody can shed some lights what heppened. Thanks in advance. - xpetstoreDS and the error: 11:34:52,275 INFO [ServiceConfigurator] Problem con

[JBoss-user] [Datasource Configuration] - Re: How to get the name of the datasource from within an EJB

2004-03-11 Thread neptune5
This is the code - I want to replace the lookup datasource.. so that the name doesn't have to be hardcoded into the program. Context context=new InitialContext(); DataSource ds=(DataSource)context.lookup("java:/PostgresDS"); Connection conn=ds.getConnection(); Statement stmt=con

[JBoss-user] [Datasource Configuration] - Which datasource-mapping value use in jbosscmp-jdbc.xml for

2004-03-11 Thread bsteinh3
Hello, which value do I have to put in the tag in the jbosscmp-jdbc.xml file for an INFORMIX Datasource ? Which datasource mappings are available ? Thanks in advance ! Bernd http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825203#3825203";>View the original post http://www.jboss.o

[JBoss-user] [Datasource Configuration] - Using two Oracle connections in a Stateless Session bean met

2004-03-10 Thread ndacherla
I am trying to connect to two databases and I get the following error message. The first connection works fine, but if I try to connect to second databse it fails. Connecting to any one database works. Any help? 14:53:33,102 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.2.3/server/d

[JBoss-user] [Datasource Configuration] - Re: creating two datasources for same database?

2004-03-10 Thread Kalimero
simply specify 2 different jndi-names: eg. | db1 | jdbc:postgresql://localhost/db | .. | | | | db2 | jdbc:postgresql://localhost/db | .. | lg wolfgang http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825087#3825087";>View the original po

Re: [JBoss-user] [Datasource Configuration] - creating two datasources for same database?

2004-03-10 Thread Wolfgang Koppenberger
arch 10, 2004 11:18 AM Subject: [JBoss-user] [Datasource Configuration] - creating two datasources for same database? > I want to configure two DataSources to connect to one DataBase, how can I do? Thanks > > http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825042#38

[JBoss-user] [Datasource Configuration] - creating two datasources for same database?

2004-03-10 Thread nagasheshu
I want to configure two DataSources to connect to one DataBase, how can I do? Thanks http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825042#3825042";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825042>Reply to the post --

[JBoss-user] [Datasource Configuration] - Couldn't send messages to a message queue in JBOSS from a re

2004-03-10 Thread mlsreekanth
Hi all, I an trying to send message to a JBOSSMQ queue which is located in a system and the system was in internetwork. I am sending using the IP address and code was as follows, java.util.Hashtable JNDIParm = new java.util.Hashtable(); JNDIParm.put(Context.PROVIDER_URL, "jnp://2

[JBoss-user] [Datasource Configuration] - Re: How to get the name of the datasource from within an EJB

2004-03-08 Thread larry054
Adrian, I don't know if there's a Jboss way to do this, but I use getMetaData. It works in any JDBC application. For example, assume con is your connection object: DatabaseMetaData dbmd=con.getMetaData(); System.out.println("You are connected to: "+dbmd.getDatabaseProductName()); B

[JBoss-user] [Datasource Configuration] - How to get the name of the datasource from within an EJB ?

2004-03-08 Thread neptune5
Hi all Is there a jboss class somewhere where you can find out the name of the datasource from within the ejb ?. Its to replace a sql statement " select max(id) from orderhead" because max can't be used from an ejbSelect method. And if I wanted to change the database I don't want to have to ch

[JBoss-user] [Datasource Configuration] - jboss 3.2.3 and arrayindexout of bound exception

2004-03-08 Thread arashb
was a fully working application in hibernate/struts/jboss3.2.2/postgreSQL 7.4 But when i tried to upgrade the jboss to 3.2.3 I get this error message: 3:44:53,497 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: org.jboss.resource.JBossResourceException: C

[JBoss-user] [Datasource Configuration] - Oracle Data Source ClassCastException when getting XA Connec

2004-03-07 Thread kalichar
I have the following configuration defined in oracle-ds.xml and the file is correclty deployed. | jdbc/SimpleDataSource | oracle.jdbc.xa.client.OracleXADataSource | jdbc:connection:thin:@localhost:1521:oracle | scott | tiger | | org.jboss.resource.ada

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-07 Thread michaellee
Dear SG, I have extracted orcale-xa-ds from 3.2.3 and modified it for sybase. I have not tested it (since 3.2 not setup) but i think it should work (may be after some minor change). Please try it out (with parameter modified to suit you environment) and inform me the result. Regards, Michael

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-07 Thread michaellee
Dear SG, AFAIK, the XML format for 3.2 and 3.0 is different (may be totally). Since i am using 3.0.6, i do not know what should be changed to make it work on 3.2. However, if you refer to the sample sybase -ds xml provided with jboss (not xa), you should get some hint to perform the amendment.

[JBoss-user] [Datasource Configuration] - Re: JDBC MBean without JAAS authentication

2004-03-07 Thread starksm
The jboss-3.2.3/docs/examples/jca/postgres-ds.xml shows this configuration. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824601#3824601";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3824601>Reply to the post ---

[JBoss-user] [Datasource Configuration] - different data types with postgresql

2004-03-07 Thread eranhovav
Hi erevryone. I work with jboss-3.2.1_tomcat-4.1.24 and PostgreSql 7.4 in a remote machine. Everything is good except this: the DS doesn't know the data type OBJECT in JMS_MESSAGES table (created in %JBOSS_HOME%/server/default/deploy/jms/jbossmq-service.xml ). Well, my question is what type i

[JBoss-user] [Datasource Configuration] - JDBC MBean without JAAS authentication

2004-03-07 Thread stefano_fornari
Hi All, I hope somebody can give me an hint on this datasource configuration issue: I would like to add a connection pool to a Postgres database, therefore I am setting up its JDBC MBean. As I understand you usually have to add JAAS realm in login-config.xml. I would like to avoid this step. Is

[JBoss-user] [Datasource Configuration] - Re: how many datasource in jboss3.2.3 ? the capability is v

2004-03-05 Thread [EMAIL PROTECTED]
You are more likely to hit a limit on open db connections in your database than a problem with the number of datasources. If you have multiple dbs, the limit will be socket connections to the different dbs. Regards, Adrian http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824445#3824445";

[JBoss-user] [Datasource Configuration] - Re: Oracle DataSource

2004-03-05 Thread [EMAIL PROTECTED]
This has nothing to do with auto-commit. It is spec defined behaviour that the insert occurs after ejbCreate and before ejbPostCreate. You can't even use CMR outside a transaction. You can delay the insert in recent versions using insert-after-ejb-post-create, see docs/dtd/jboss_3_2.dtd or use sea

[JBoss-user] [Datasource Configuration] - Re: XADatasource

2004-03-05 Thread [EMAIL PROTECTED]
Yes and two phase commit. Regards, Adrian http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824443#3824443";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3824443>Reply to the post --- This

[JBoss-user] [Datasource Configuration] - Re: Problem understanding commit()

2004-03-05 Thread [EMAIL PROTECTED]
Post the errors rather than "I've got a problem". Most likely you are inside a JTA transaction where manual commit() is not allowed. Regards, Adrian http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824442#3824442";>View the original post http://www.jboss.org/index.html?module=bb&op=pos

[JBoss-user] [Datasource Configuration] - Problem understanding commit()

2004-03-05 Thread jdavis
I've gotten errors using the connection.comit() method. If I remove the commit method everything is fine. I would greatly appreciate any information on how JBoss manages commits or a pointer to where I should be looking in the docs - I am reading the manual :) Thanks, Jeremy http://www.jboss.

[JBoss-user] [Datasource Configuration] - Re: How to configure more than one DataSource in Jboss3.2? T

2004-03-05 Thread vegehead
What do u mean by deploying 2 different xml files? are they using the same names? i am sure they are not. Then what is the appropriate name for the next xml file? Thanks. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824365#3824365";>View the original post http://www.jboss.org/index

[JBoss-user] [Datasource Configuration] - how do you configure logging for a datasource?

2004-03-04 Thread davekohr
I'm trying to upgrade my JBoss from 3.0.6 to 3.2.3, and having problems with a few (but not all) of our EJB's. I'm using the MS SQLSERVER2000 datasource, with JBoss and the database running on the same Windows 2000 host. I am beginning to think that something in the EJB implementation has changed,

[JBoss-user] [Datasource Configuration] - Oracle DataSource

2004-03-04 Thread hoffz31
Is it possible to turn auto commit off in the data source file? I am getting an error using CMR. I keep getting can not insert null into the foreign key column after the initial insert. Does all foreign key columns have to be nullable to get CMR to work? http://www.jboss.org/index.html?module

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-04 Thread sgopinathan
Thanks for your interest in this problem. Here is some more information on the configuration I am using: I am using jboss-3.2.1_tomcat-4.1.24. When drop the sybase-xa-service.xml in the deploy directory just changing the database name and user id /pwd. I get this error org.jboss.deployment.De

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-03 Thread pilhuhn
Why don't you just provide a jndi-name instead of remving that element? http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824070#3824070";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3824070>Reply to the post ---

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-03 Thread sgopinathan
This is great. I had been searching the entire net for someone who had tried using sybase xa connection. Anyway when I tried using this sybase-xa-service.xml by copying it to the deploy directory of jboss 3.2.1, it complained that attribute is not defined. When I removed the line , I got

[JBoss-user] [Datasource Configuration] - Re: How to configure more than one DataSource in Jboss3.2? T

2004-03-03 Thread darranl
Deploy two different *-ds.xml data source files. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3824047#3824047";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3824047>Reply to the post --

[JBoss-user] [Datasource Configuration] - XADatasource

2004-03-03 Thread aquila125
Hi there, I'm pretty new to the jboss scene. Can I use transactions without a XADatasource? If so, whats the difference between a normal an a XADatasource? tnx http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823973#3823973";>View the original post http://www.jboss.org/index.html?mo

[JBoss-user] [Datasource Configuration] - How to configure more than one DataSource in Jboss3.2? Thank

2004-03-02 Thread nimrod
I want to configure two DataSource to connect to two different DataBase, how can I do? Thanks. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823946#3823946";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823946>Reply to the post ---

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-02 Thread michaellee
The sybase-xa-service.xml seem to be corrupted during cut and pate. Following is the content. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | jdbc/SybaseFMS

[JBoss-user] [Datasource Configuration] - Sybase XADataSource

2004-03-02 Thread michaellee
I have just set up an XADataSource for ASE 12.5 using jConnect 5.5 on Jboss 3.0.6. Since it is not so straightforward, i would like to share it with anyone interested. Following modification is required: . ra.xml inside jboss-xa.rar - for 3.0.6, there is a problem (seem to be a bug and should

[JBoss-user] [Datasource Configuration] - how many datasource in jboss3.2.3 ? the capability is very

2004-03-02 Thread wjw
how many datasource in jboss3.2.3 ? the capability is very good yet? thanks!! http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823924#3823924";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823924>Reply to the post

[JBoss-user] [Datasource Configuration] - Re: jboss mysql problem

2004-03-02 Thread CopyKat
the password tag is like this but no spaces < password > password < / password > http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823893#3823893";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823893>Reply to the post -

[JBoss-user] [Datasource Configuration] - Re: jboss mysql problem

2004-03-02 Thread CopyKat
sorry that is my mysql-ds config file DefaultDS jdbc:mysql://localhost:3306/jbossdb org.gjt.mm.mysql.Driver jboss password http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823892#3823892";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply

[JBoss-user] [Datasource Configuration] - Re: Connection pool leak if transaction marked for rollback?

2004-03-02 Thread joehung
I've seen exactly the same exception sequence you mentioned in the archive message. the problem appears when we keep stop/start the datastore and *intentionally* cause the connection to fail to see if the connection pool can recover. We are forced to work around this problem by restarting JBoss

[JBoss-user] [Datasource Configuration] - Re: How to encrypt the username and password in -db-service.

2004-03-02 Thread Martin0
In fact the answer from Scott is here http://www.jboss.org/index.html?module=bb&op=viewtopic&t=45111 http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823839#3823839";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823839>Reply to the post -

[JBoss-user] [Datasource Configuration] - ClassCastException when trying to deploy hibernate.sar

2004-03-02 Thread mugwump
I'm struggling with a strange problem, that occurs when i try to deploy hibernate as a .sar (as outlined in http://www.hibernate.org/66.html). I'm getting: 16:18:24,002 FATAL [DatasourceConnectionProvider] Could not find datasource: java:/devbaseDS java.lang.ClassCastException at net.

[JBoss-user] [Datasource Configuration] - Trying to return an unknown connection (hibernate)

2004-03-02 Thread reva
platform : hibernate 2.1 jboss 3.2.2 mysql 4.0 situation Accessing the database through hibernate from a stateless sessionbean throws an illegalStateException : Trying to return an unknown connection case When a user logs on to the application I need to verify the user and create an applicatio

[JBoss-user] [Datasource Configuration] - Re: Connection pool leak if transaction marked for rollback?

2004-03-02 Thread amayingenta
We had this problem with 3.2.1 (with a LocalTx Datasource). Most of the problem turned out to be our application doing something dumb :) but there also appears to be a bug in the connection pooling. See http://www.mail-archive.com/[EMAIL PROTECTED]/msg30247.html I'm afraid I never raised a bug

[JBoss-user] [Datasource Configuration] - Wrong Database used

2004-03-01 Thread michaellee
Hi, I am using Jboss 3.0.6 with sybase ase 12.5 (JConnect 5.5). When backend database restart (after failure), connection to the database server is allowed but individual database cannot be accessed until recovery complete. Under such a situation, the "master" database is used (a warning messag

[JBoss-user] [Datasource Configuration] - Trying to get Petstore to work with JBoss 3.2.3

2004-03-01 Thread kaisaab
I am trying to get Sun's petstore application to run on JBoss 3.2.3 but I am facing some challenges. I was able to deploy the xpetstore to run and it as it local database(Pointbase) and I need it to connect to Oracle 9i database. Has anyone had recent success being able to deploy a petstore app

[JBoss-user] [Datasource Configuration] - Re: Connection pool leak if transaction marked for rollback?

2004-03-01 Thread joehung
I too am seeing this problem in 3.2.1. I'm not sure if it's the same one but it sounds too familiar. Have you found a solution yet? -joe View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823663#3823663 Reply to the post : http://www.jboss.org/index.html?module

[JBoss-user] [Datasource Configuration] - Re: Datasource passwords showing in server.log

2004-03-01 Thread starksm
There is no setting that will prevent this. The properties that are dumped needs to have the password masked. This will be added for the 3.2.4RC1 release. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823661#3823661 Reply to the post : http://www.jboss.org/

[JBoss-user] [Datasource Configuration] - Datasource passwords showing in server.log

2004-03-01 Thread togath
I have configured my datasource and am able to connect, but very time that I do I get the user name and password for the database being shown in the server.log. These two items are only shown when the log level is DEBUG, but is there any way to mask the output of the user name and password? I

RE: [JBoss-user] [Datasource Configuration] - Setting custom Connection Properties

2004-03-01 Thread Peter Ondruska
[EMAIL PROTECTED] Subject: [JBoss-user] [Datasource Configuration] - Setting custom Connection Properties Date: Mon, 1 Mar 2004 10:55:07 -0500 (EST) I want to set an Oracle connection property (TCP.NODELAY=YES) on a previously configured JDBC connection. I had thought adding TCP.NODELAY=YES I

[JBoss-user] [Datasource Configuration] - Setting custom Connection Properties

2004-03-01 Thread magnayn
I want to set an Oracle connection property (TCP.NODELAY=YES) on a previously configured JDBC connection. I had thought adding TCP.NODELAY=YES Into my jboss-service.xml would do the trick, but it claims there is no such property on ManagedConnectionFactoryProperties (even though I can see it

[JBoss-user] [Datasource Configuration] - Simple JDBC encryption request

2004-03-01 Thread bobs
I'm running jboss-3.2.1 with its oracle-ds.xml configured with to use Oracle's thin jdbc driver to talk to my Oracle database - all works well. I now wish to encrypt this jdbc link between jboss and Oracle. I'd assume this was an easy task, but I can't find any 'specifics' on how to do it. A

[JBoss-user] [Datasource Configuration] - Re: How to configure a data source

2004-03-01 Thread biondo79
no View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823588#3823588 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823588 --- SF.Net is sponsored by: Speed Start Your L

[JBoss-user] [Datasource Configuration] - Re: Can't get an XAConnection please help

2004-03-01 Thread schrouf
This is not a JBoss problem ! Your user is simply rejected by your MySQL-Server ! Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Make sure that [EMAIL PROTECTED] is configured as valid user within MySQL-DB ! View the original post : htt

[JBoss-user] [Datasource Configuration] - Re: Postgresql connection error

2004-03-01 Thread neptune5
hi thanks for that now got the connection working to the postgre db. Now all I need to do is get it to create the tables properly. Seems to be more picky about how the cmp-jdbc file is written ! , as they are created ok in hypesonic but only 2 under postgres are done. Regards Adrian View the o

[JBoss-user] [Datasource Configuration] - Can anyone help me, i can't configure my JBoss 3.2.3 with my

2004-03-01 Thread petemitchell
Hi, I'm pretty new to Jboss and i already like it :) I have mysql Server 4 installed and JBoss 3.2.3 and i'd like to set up mysql to be the default database for JBoss. I tried many examples but when i run JBoss, i have an error, mysql-service.xml and jbossstandard-cmp.xml aren't properly configu

[JBoss-user] [Datasource Configuration] - hibernate class cast problem

2004-02-29 Thread getagrip
I do the following as stated in the documentation: Context ctx = new InitialContext(); SessionFactory factory = (SessionFactory)ctx.lookup("java:/DefaultDS"); However the second line throws a ClassCastException because ctx.lookup returns an Object of type: org.jboss.resource.adapter.jdbc.Wrappe

[JBoss-user] [Datasource Configuration] - ExceptionSorter when connection is not availble during JBoss

2004-02-29 Thread richaosu
I'm just read how the ExceptionSorter class can be used to reconnect a lost connection. I can see that this will provide a reconnect service when the connection is lost after JBoss is running. Question: Will the ExceptionSorter resolve connection issues during a JBoss boot? Scenario: 1) Datasou

[JBoss-user] [Datasource Configuration] - Can't get an XAConnection please help

2004-02-29 Thread joseph2003
Hi, I'm using jboss 2.4.10_tomcat 4.0.6. while trying to connect to the data base (mysql 4.0.18) i get the following error [ERROR,XAConnectionFactory] Can't get an XAConnection java.sql.SQLException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using pass

[JBoss-user] [Datasource Configuration] - Re: Best practice on DS-independent deployment?

2004-02-29 Thread pilhuhn
Yes, that is correct wrt datasource and mapping elements. If you know, that you will have only ond datasource, it really is the best to just use the defaults. The NamingAlias MBean provides you sort of "soft link" functionality. Use an MBean org.jboss.naming.NamingAlias | | jndi-nam

[JBoss-user] [Datasource Configuration] - Re: Best practice on DS-independent deployment?

2004-02-29 Thread csp
Sorry if I'm not following you on the alias MBean. Mind giving more details on which MBean are you referring to? I found that I can remove the two elements and from jbosscmp-jdbc.xml and it will take the DefaultDS. According to the dtd, these two are optional. Thanks csp View the original

[JBoss-user] [Datasource Configuration] - Re: Best practice on DS-independent deployment?

2004-02-29 Thread pilhuhn
There is a naming alias Mbean, that you can use to alias a DS. I.e. your application specifies fooDS and the Mbean aliases it to realDS. There is no such mechanism for the DS-mapping so far. There are two feature requests open regarding this. View the original post : http://www.jboss.org/index.

[JBoss-user] [Datasource Configuration] - Best practice on DS-independent deployment?

2004-02-29 Thread csp
Is there a way to make your bean's deployment descriptor really DS-independent? For example, in jbosscmp-jdbc.xml, you have to specify datasource-mapping. Otherwise, jboss will complain that it's an invalid descriptor file. It would have been nice if I don't have to specify that mapping element

[JBoss-user] [Datasource Configuration] - Re: Question about postgresql datasource

2004-02-29 Thread csp
Got it, just because "desc" is reserved word in Postgresql. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823447#3823447 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823447 ---

[JBoss-user] [Datasource Configuration] - Re: How to encrypt the username and password in -db-service.

2004-02-29 Thread Martin0
I would imagine the answer is to use JCE to encrypt the whole file, and customise the thing that reads this file to decrypt it. A bit of work but probably the answer. Martin View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823446#3823446 Reply to the post :

[JBoss-user] [Datasource Configuration] - Question about postgresql datasource

2004-02-28 Thread csp
I'm trying to setup JBoss (4.0DR3) to use Postgresql (7.4) datasource on Linux (Debian with kernel 2.4.22). Have no problem accessing PG with JDBC, and just couldn't get JBoss to use the datasource properly. Ok, here's what I did. Copy postgresql-jdbc3.jar into the directory $JBOSS_HOME/serve

[JBoss-user] [Datasource Configuration] - Exception accessing DataSource

2004-02-28 Thread [EMAIL PROTECTED]
I am facing an error I am trying to configure Microsoft Access as DataSource Therefore I copied msaccess-ds.xml to E:\jboss-3.2.3\server\default\deploy with some changes I have made a DSN named CSO which points to cso.mdb in my Windows 2000 System The Whole code is copied into I am new to JBos

[JBoss-user] [Datasource Configuration] - Oracle91 xaDatasource driver for 2pc

2004-02-28 Thread brickpaul
I'm using Jboss3.2.3, Oracle9i and JbuilderX Enterprise Hello all. Does anyone know what driver I should use for 2pc? I tried the config below and it doesn't work. I get no errors but when the insert is part of a UserTransaction it just doesn't commit with txn.commit() but I can do a select stat

[JBoss-user] [Datasource Configuration] - Re: Difference between DataSource and XADataSource

2004-02-27 Thread murthytvsn
XA datasource for distributed databases View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823338#3823338 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823338 --- SF.Ne

[JBoss-user] [Datasource Configuration] - mysql driver register failure

2004-02-27 Thread robdiana
I have configured my data source for mysql and overall it works ok. The problem that I have is the first time JBoss is started, my first attempt to connect to the mysql datasource returns a "Failed to register driver" exception. I am using jboss 3.2.1, mysql 3.23.54 and the mysql 3.0.6 connector

[JBoss-user] [Datasource Configuration] - MSAccess JDBC Datasource Configuration Example

2004-02-27 Thread [EMAIL PROTECTED]
Can anyone give me link for the JDBC DataSource Configuration Example Thanks in advance View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823303#3823303 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823303 ---

[JBoss-user] [Datasource Configuration] - Difference between DataSource and XADataSource

2004-02-27 Thread nadaya
Hello excused my ignorance but that difference there is between a DataSource and a XADataSourceor in general between that start with XA and another than dont start with XA Thanks for all View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823257#3823257

[JBoss-user] [Datasource Configuration] - Re: Connectiion pool behavior.....

2004-02-27 Thread IslamSakka
Well, you have got a DataSource instance from the connection pool you just configured, so yes, you can assume that you are using the connection pool :) . A good practice is to cache the handle to the connection pool DataSource(The DataSource) for performance reasons. View the original post :

[JBoss-user] [Datasource Configuration] - Re: JBoss & MSSQL database server connection problem

2004-02-27 Thread dannyyates
No need to get moody. You problem isn't necessarily every body else's problem. If you really need help, you could always pay for support. Anyway... if you look at the exception, you'll see that one of the things being waited for is "jboss.jca:service=LocalTxCM,name=DefaultDS". You'll also notice

[JBoss-user] [Datasource Configuration] - Re: JBoss & MSSQL database server connection problem

2004-02-27 Thread jburugupalli
i use this and it works fine AIWORKDB jdbc:inetdae://localhost/AIDB com.inet.tds.TdsDriver AIWORKUSER heiko 0 50 5000 15 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823241#3823241 Reply to the post : http

RE: [JBoss-user] [Datasource Configuration] - Re: JBoss & MSSQL d atabase server connection problem

2004-02-27 Thread Godley, Robert C
ta -Original Message- From: Dillinger [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 10:15 To: [EMAIL PROTECTED] Subject: [JBoss-user] [Datasource Configuration] - Re: JBoss & MSSQL database server connection problem Well just forget it. Seems like the information about this essu

[JBoss-user] [Datasource Configuration] - Re: JBoss & MSSQL database server connection problem

2004-02-27 Thread Dillinger
Well just forget it. Seems like the information about this essue is very poor!! Have seen a whole lot of question about JBOSS and database connections without any answers. I'll write my own database handler, and deploy that instead View the original post : http://www.jboss.org/index.html?module

[JBoss-user] [Datasource Configuration] - Re: CANNOT lookup on a datasource

2004-02-26 Thread moghrabi
Thank you for your response but how can I get a connection to my DBMS for simple objets using Jboss Connection Pool ? Is it possible ? In fact I have objets which use JDBC and I want to use the connection as defined in jboss/deploy. Xavier MOGHRABI View the original post : http://www.jboss.o

[JBoss-user] [Datasource Configuration] - Re: CANNOT lookup on a datasource

2004-02-26 Thread [EMAIL PROTECTED]
Deploy a server side component, like a SLSB, that talks to your datasource. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823093#3823093 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823093

[JBoss-user] [Datasource Configuration] - How to configure a data source

2004-02-26 Thread biondo79
Hi! IÂm getting started into JBoss and I would like to know how to configure a datasource. IÂm working with an Oracle db. Once I configure my datasource, is there necesary any aditional steps to deploy my JAR files? (Besides putting all my jar files into the deploy directory), best regards!! B

  1   2   3   4   >