[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: problem with datasource + mysql + jboss
so you got me thinking on the right track... it was due to a persistence.xml config that had hibernate login info overriding the datasource config. I removed the username/passwd from the persistence.xml and all it good now. Thanks! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4205399#4205399 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4205399 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Installation, Configuration & DEPLOYMENT] - problem with datasource + mysql + jboss
Hi, I've configured two datasources in /server/default/deploy, as shown below, and one goes to oracle, and the other goes to mysql. Problem is this... I can connect to mysql via a java test program, but it won't connect from jboss. Funny thing is that it is using a username that I've taken out of the datasource definitions all together... (It is one of my usernames, but just not in the ds config files).. Please help... Thanks! Env: MySQL: Server version: 5.0.32-Debian_7etch8-log Connector: mysql-connector-java-5.1.7-bin.jar jboss-4.2.2.GA Debian/Unix Error: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) | at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171) | ... 158 more | Caused by: java.sql.SQLException: Access denied for user 'gs'@'localhost' (using password: YES) | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911) | at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953) | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276) | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2198) | ... 162 more | :: GSModel-ds.xml :: | | | GSModelDS | jdbc:oracle:thin:@localhost:1521:xe | oracle.jdbc.driver.OracleDriver | gsora | x | | | :: GSMySQL-ds.xml :: | | | GSMySQLModelDS | | jdbc:mysql://localhost/gstemp1 | com.mysql.jdbc.Driver | gs2 | x | true | | | mySQL | | | | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4205388#4205388 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4205388 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JNDI/Naming/Network] - Re: Why does jbossall-client.jar cause
I figured out the problem I was having, and hopefully this may help you...
Make sure to put a try-catch around the entire body of code for your EJB
interfaces. Basically I was having a problem with the SLSB.method, when it
tried to invoke a SFSB.method2.
I my body of code for "SLSB.method" I had
lookup("SFSB"), and in Oracle this works fine, but for Jboss, I had to put
"SFSB/local", and forgot to change the interface to Local as well, hense my
SLSB.method was getting a ClassCastException, which propogated to the CLIENT as
a null exception or ClassCastException with some sort of $Proxy cause...
Anyway once I straightened this out, my Client worked OK.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4077038#4077038
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4077038
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JNDI/Naming/Network] - Re: Why does jbossall-client.jar cause
I am interested in solving this problem as well - I have worked on this for the
last 1.5 days, and searched the forums for a solution, but can't find any? Has
anyone been able to get a REMOTE EJB3 client working with jboss? If so please
explain the steps...
If I include my jar file that has the EJBs in my client's classpath, I get
class cast exceptions.
If I dont' then I get rmi security exceptions ("no security manager: RMI class
loader disabled") - If someone knows how to get past the security problem, that
would be great to know..
Thanks!
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4076967#4076967
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4076967
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: @DataModel modifications
Georges, I am having almost the same problem. My scenario is different, but the DataModel is being cached... and if I change the datamodel to stateless or the SFSB to SLSB, it complains w/ exceptions. How did you solve your problem? Can you give me code samples? Thanks! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4052435#4052435 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4052435 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: Getting Id of Presisted object.
my xml didn't show up in the previous post - I will enclose in "code" tags - this is what I had to get rid of : View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4045823#4045823 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4045823 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: Getting Id of Presisted object.
I fixed the problem - it was that the persistance.xml had the following defined. I needed this to run the "seam generate-entities" or else all the tables in the system space were being generated to. Thank you for your code suggestion. -Joel View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4045821#4045821 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4045821 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: Getting Id of Presisted object.
I fixed the problem - it was that the persistance.xml had the following defined. I needed this to run the "seam generate-entities" or else all the tables in the system space were being generated to. Thank you for your code suggestion. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4045822#4045822 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4045822 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: Getting Id of Presisted object.
Sorry. I know this is slightly off topic of your question - please forgive me. but I am still having the same problem whereby, it says the sequence does not exists... I am using jboss-4.0.5.GA w/EJB installed on Window XP runing 10g XE on same machine. This one issue is enough to kill my project in SEAM, and I really wanted to give this a try. I need to be able to use SEQUENCE directly or before insert triggers (which invoke the sequence before actual insert). I don't care which way I go, but if I use the method proposed here, I get: --- MBeans waiting for other MBeans --- | ObjectName: persistence.units:ear=naturalmed2.ear,unitName=naturalmed2 | State: FAILED | Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Missing sequence or table: NM.LISTINGTYPE_SEQ | I Depend On: | jboss.jca:service=DataSourceBinding,name=naturalmed2Datasource | | --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- | ObjectName: persistence.units:ear=naturalmed2.ear,unitName=naturalmed2 | State: FAILED | Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Missing sequence or table: NM.LISTINGTYPE_SEQ | I Depend On: | jboss.jca:service=DataSourceBinding,name=naturalmed2Datasource and again, the sequence is there (double checked). Also, I should mention that I am working with the code generated by SEAM generate-entities. Thank you for any help you can give. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4045659#4045659 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4045659 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: Getting Id of Presisted object.
Thanks for the info on the sequence - but it still gives me the same problem: 12:15:22,362 ERROR [URLDeploymentScanner] Incomplete Deployment listing: --- MBeans waiting for other MBeans --- ObjectName: persistence.units:ear=naturalmed2.ear,unitName=naturalmed2 State: FAILED Reason: javax.persistence.PersistenceException: org.hibernate.HibernateExcepti on: Missing sequence or table: NM.LISTINGTYPE_SEQ I Depend On: jboss.jca:service=DataSourceBinding,name=naturalmed2Datasource --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: persistence.units:ear=naturalmed2.ear,unitName=naturalmed2 State: FAILED Reason: javax.persistence.PersistenceException: org.hibernate.HibernateExcepti on: Missing sequence or table: NM.LISTINGTYPE_SEQ I Depend On: jboss.jca:service=DataSourceBinding,name=naturalmed2Datasource And I have double checked that the sequence is there in that NM schema... This is consistent with what I have notice with other attempts too. Any thoughts? Thanks again! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4045108#4045108 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4045108 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: Getting Id of Presisted object.
Hello, can someone give me some advice on how to setup a generated ID with Oracle, hibernate and SEAM... I have been trying to do a variety of ways - like "before insert" triggers and coupled with @GeneratedValue(strategy=GenerationType.IDENTITY) or @GeneratedValue(strategy=GenerationType.AUTO), but that didn't work. I have tried going straight to the sequence with: @Id @Column(name = "LISTINGTYPE_ID", unique = true, nullable = false, precision = 22, scale = 0) @SequenceGenerator(name="identifier", sequenceName="LISTINGTYPE_SEQ", allocationSize=1) @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="identifier") @NotNull That didn't work, it kept complaining the sequence didn't exist, although it did exist. I have read a dozen or more postings and can't get the right recipe working for Oracle. I really appreciate your help. Thanks!!! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4044919#4044919 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4044919 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: many-to-many (dynamically shown) on same JSF page
I'd like some help with how the JSF dataTable
and single/multi selects are setup and how to setup
the SLSB to handle the SAVE on this scenario.
Here are the objects and tables roughed in .
public class Person
{
String FNAME="";
List preferences=null;
@ManyToMany
@JoinTable (name="Person_SysPref"
[EMAIL PROTECTED](name="PERSON_ID"),
[EMAIL PROTECTED](name="PREF_ID"))
public List getPreferences()
{
return preferences;
}
... w/ getters and setters
}
public class Pref
{
String name="";
String selected="";
String group="";
... w/ getters and setters
}
~ tables ~
create table Person
(
PERSON_ID number primary key, -- surrogate generated key by person_seq
sequence
FNAME varchar2(30)
);
create table SysPref
(
SYSPREF_ID number primary key, -- surrogate generated key by SysPref_seq
sequence
NAME varchar2(30),
GRP varchar2(20)
);
create table Person_SysPref
(
PERSON_SYSPREF_ID number primary key,
SYSPREF_ID number, --fk to SysPref
PERSON_ID number -- fk to Person table
selected char(1)
);
The front end :
a create form to input the Person.FNAME
and on same form a list of Pref options (derived directly from the SysPrefs
table).
Once I hit the "SAVE" button (it is bound to SLSB, not shown here), the
Person will be CREATED, and then I loop though all the "preferences" store
all of them in the Person_SysPref table, with selected flag for that Person.
The concept of "injecting" the Person object into a SLSB is clear from
samples,but how do I get the list of Preferences (available from the SysPrefs)?
And then once I have Person object existing, how do I associate this list of
Prefs directly with the Person.preferences instead of the SysPrefs?
One last thing - on the UI, I'd like to be able to group the preferences by the
GRP value - for example,
colors: (single select radio buttons)
red
green
blue
size: (single select radio buttons)
small
med
lg
Favorite Sports: (multiselect check boxes)
hiking
biking
running
If you can give me some general direction or even code examples. on this, I'd
really appreciate it.
Thanks again!
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4039385#4039385
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4039385
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: generate-entities generating all the tables including sy
thanks! I'll check that out (hibernate.default_schema) - I redid my "setup" and specified the schema and that worked. You'd think it would default to the "user", if not specified - but perhaps that may be too specific behaviour to Oracle and not other database vendors. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4037681#4037681 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4037681 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - Re: many-to-many (dynamically shown) on same JSF page
Hello Petemuir - thanks for replying - I just gave these as examples of a many-to-many relationship. I don't have them to post, but besides it is a bit irrelevant since the question is really about what is the best way to manage dynamically generated jsf-seam components that have a master-detail relationship; where we want to have the "details" editable/saveable along with the master from the same screen. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4037650#4037650 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4037650 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - generate-entities generating all the tables including system
for some reason "seam generate-entities" is giving all the tables (including system tables) in my oracle 9i database (w/ 10g jdbc driver). How can I limit it to just the tables in my user's schema? [hibernate] WARNING: The JDBC driver didn't report any primary key columns in US | ER_REPCOLUMN. Asking rev.eng. strategy | [hibernate] Apr 16, 2007 9:31:37 AM org.hibernate.cfg.reveng.JDBCReader processP | rimaryKey | [hibernate] WARNING: Rev.eng. strategy did not report any primary key columns fo | r USER_REPCOLUMN | [hibernate] Apr 16, 2007 9:31:37 AM org.hibernate.cfg.reveng.JDBCReader processP | rimaryKey | [hibernate] WARNING: The JDBC driver didn't report any primary key columns in US | ER_REPCOLUMN_GROUP. Asking rev.eng. strategy | [hibernate] Apr 16, 2007 9:31:37 AM org.hibernate.cfg.reveng.JDBCReader processP | rimaryKey | [hibernate] WARNING: Rev.eng. strategy did not report any primary key columns fo | r USER_REPCOLUMN_GROUP | [hibernate] Apr 16, 2007 9:31:37 AM org.hibernate.cfg.reveng.JDBCReader processP | rimaryKey Thanks! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4037648#4037648 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4037648 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Seam] - many-to-many (dynamically shown) on same JSF page
Hello, Lets say i have a user that has a M-M relationship with preferences. The preferences should show up as "Checkboxes" or "RadioButtons" on the screen. I create the POJO user class with a Set of preferences annotated with Many-to-Many. The list of available preferences (from the system) are database driven - So I can't hard code the JSF page with the components and conversely I can't have the backing bean with the data controls there. Question: if I want one JSF page with User attributes and this list of preferences to show up underneath the user info, and I want to have one SAVE button that will save the entire graph of objects, what is the best way to do this? I know I can create a backing bean (w/ action handler on the save button) and loop through the parameters and setup the preference objects that way, but I was hoping that there is some sort of component or pattern that I can take advantage of in SEAM or JSF. Thanks! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4037273#4037273 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4037273 ___ jboss-user mailing list [EMAIL PROTECTED] https://lists.jboss.org/mailman/listinfo/jboss-user
